SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
alias/phpmyadmin.conf
ssl://email-smtp.eu-central-1.amazonaws.com
----
alias/phpmyadmin.conf

4000000000000002	Visa	123

/**************************** neoleap *************************/
Card Number

5105105105105100

Expiry Date

12/24

CVV

123

OTP

123123
/**************************** neoleap *************************/

@media (min-width: 576px) { ... }

// Medium devices (tablets, 768px and up)
@media (min-width: 768px) { ... }

// Large devices (desktops, 992px and up)
@media (min-width: 992px) { ... }

// Extra large devices (large desktops, 1200px and up)
@media (min-width: 1200px) { ... }


----
7/3/2024
ALTER TABLE `customer_subscription_history` CHANGE `Transfer_Holder_Name` `Transfer_Holder_Name` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
product_program -- table

ALTER TABLE `lessons` ADD `program_id` INT(6) NULL AFTER `Status`;
ALTER TABLE `lessons` CHANGE `chapterNo` `chapterNo` INT(5) NULL;
ALTER TABLE `lessons` CHANGE `partNo` `partNo` INT(5) NULL;
ALTER TABLE `lessons` CHANGE `chapterTitle_ar` `chapterTitle_ar` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `lessons` CHANGE `chapterTitle_en` `chapterTitle_en` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `lessons` CHANGE `partTitle_ar` `partTitle_ar` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `lessons` CHANGE `partTitle_en` `partTitle_en` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `lessons` CHANGE `lessons_name_ar` `lessons_name_ar` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `lessons` CHANGE `lessons_name_en` `lessons_name_en` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `promo_codes` ADD `AmountWallet` INT(6) NULL DEFAULT '0' AFTER `marketer_commission_rate`;
ALTER TABLE `promo_codes` ADD `IsWalletAmount` INT(1) NULL DEFAULT '0' AFTER `marketer_commission_rate`;

UPDATE `products` SET `broadcast_end_date`= NULL WHERE broadcast_end_date= '0000-00-00';
UPDATE `products` SET `end_date_templete`= NULL WHERE end_date_templete= '0000-00-00';
UPDATE `products` SET `start_date_live`= NULL WHERE start_date_live= '0000-00-00';

ALTER TABLE `products` ADD `IS_Wallet_Amount` INT(2) NULL DEFAULT '0' AFTER `Plan_ExpiresDate`, ADD `Wallet_Amount` INT(6) NULL AFTER `IS_Wallet_Amount`;
ALTER TABLE `appointments_customers` ADD `is_send_before_one_day` INT(1) NULL DEFAULT '0' AFTER `Status_request`, ADD `is_send_before_three_hour` INT(1) NULL DEFAULT '0' AFTER `is_send_before_one_day`;
ALTER TABLE `product_appointments` ADD `date_all` DATETIME NULL AFTER `to_time`;
site/cronjob/Special_courses_reminder_before_one_day_email -- cronjob

product_live_special -- table

ALTER TABLE `products` ADD `product_end_appointment` DATE NULL AFTER `product_gateway_payment`;
ALTER TABLE `products` ADD `product_is_program` INT(1) NULL DEFAULT '0' AFTER `product_end_appointment`;
ALTER TABLE `product_appointments` ADD `Status` INT(1) NOT NULL DEFAULT '1' AFTER `date_all`;
ALTER TABLE `login_logs` CHANGE `region` `region` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `login_logs` CHANGE `city` `city` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `customer_subscriptions` ADD `cunt_recurring` INT(5) NOT NULL DEFAULT '0' AFTER `is_recurring_payment`;


-------------------------------------
2/5/2024
ALTER TABLE `news` ADD `news_views` INT(11) NOT NULL AFTER `auther_name_en`;


03/05/2024
------------------------------------
ALTER TABLE `products` ADD `is_table_lessons` INT(1) NULL DEFAULT '0' AFTER `product_sequence`;
ALTER TABLE `promo_codes` ADD `Max_Amount` FLOAT NOT NULL AFTER `DiscountValue`;
ALTER TABLE `promo_codes` CHANGE `Max_Amount` `Max_Amount` FLOAT NOT NULL DEFAULT '0';
ALTER TABLE `login_logs` ADD `latitude` VARCHAR(100) NULL AFTER `city`, ADD `longitude` VARCHAR(100) NULL AFTER `latitude`;

tables:
news_cunt_visitor
----------------------------------------
10/06/2024
INSERT INTO `rbac_menus` (`Id`, `Menu_String_Key`, `Link`, `Icon`, `JS_Function`, `Is_SideBar_Menu`, `Menu_Key`, `Order_In_List`, `Parent_ID`) VALUES (NULL, 'reports', '#', 'fa fa-file-text', '', '1', 'reports', '20', '0');

INSERT INTO `rbac_menus` (`Id`, `Menu_String_Key`, `Link`, `Icon`, `JS_Function`, `Is_SideBar_Menu`, `Menu_Key`, `Order_In_List`, `Parent_ID`) VALUES (NULL, '219', 'acp/reports', '', '', '1', 'courses reports', '3', '74');
INSERT INTO `rbac_menu_actions` (`MA_ID`, `Menu_ID`, `Action_ID`) VALUES (NULL, '74', '5');
INSERT INTO `rbac_menu_actions` (`MA_ID`, `Menu_ID`, `Action_ID`) VALUES (NULL, '75', '5');


----------------------------------------
28/8/2024
39606
39611
39610
39605
39600
39598
39593
39602
39597
39590
19330
19318
18837
19289
18807
18783
18682
18679
18683
18681
18680
18678


UPDATE `customer_subscriptions` SET `is_recurring_payment`=0 WHERE `CS_ID`in(39606,39611,39610,39605,39600,39598,39593,39602,39597,39590,19330,19318,18837,19289,18807,18783,18682,18679,18683,18681,18680,18678);

---------------------------------------
1. مشكلة نسبة الانجاز
2. مشكلة عندما يستخدم كود خصم  100%  يظل يضغظ ويضيف من جديد
3. عندما يكون في دورة مسجلة بس فيها بص مباشر يظهر في صفحة عرض الانشطة الموعد
4. التاريخ خطا عند رد المدرب على المشاركة للمتدرب
5. مشكلة الكتاب
6. مشكلة الدفع المتكرر تعت الملاحظات .. ارجع الكول باك فاضي

-------
ALTER TABLE `products` ADD INDEX(`product_id`);
DROP TABLE emails_templete;
-----
ALTER TABLE `website_settings` ADD `Website_Currancy` VARCHAR(500) NULL AFTER `Website_Language`;